

In [1]:

    
import astroquery
print(astroquery.__version__)

Vizier Queries



In [2]:

    
from astroquery.vizier import Vizier
catalog_list = Vizier.find_catalogs('Kennicut')
['{}: {}'.format(k, v.description) for k, v in catalog_list.items()]









    Out[2]:





['VII/141: Spectrophotometric Atlas of Galaxies (Kennicutt Jr. 1992)',
 'J/ApJ/463/26: VI photometry of 29 Cepheids in M101. (Kelson+ 1996)',
 'J/ApJ/507/655: VI photometry of new Cepheids in NGC 2541 (Ferrarese+, 1998)',
 'J/ApJ/508/491: M101 Cepheids (Stetson+, 1998)',
 'J/ApJ/510/104: Ionizing Stars of Extragalactic H II Regions (Bresolin+ 1999)',
 'J/ApJ/512/48: VI photometry of new Cepheids in NGC 4725 (Gibson+, 1999)',
 'J/ApJ/514/614: VI photometry of new Cepheids in NGC 3198 (Kelson+, 1999)',
 'J/ApJ/523/540: VI photometry of new Cepheids in NGC 3319 (Sakai+, 1999)',
 'J/ApJ/529/723: VI photometry of Cepheids (Gibson+, 2000)',
 'J/ApJ/633/871: Positions and photometry of HII knots in M51 (Calzetti+, 2005)',
 'J/ApJ/646/161: Classification of IR galaxies (Dale+, 2006)',
 'J/ApJ/648/987: UV through far-IR analysis of M81 (Perez-Gonzalez+, 2006)',
 'J/ApJ/656/770: Mid-IR spectrum of star-forming galaxies (Smith+, 2007)',
 'J/ApJ/661/801: Survey for ionization in neutral gas galaxies. III. (Oey+, 2007)',
 'J/ApJ/669/959: Warm molecular hydrogen in SINGS galaxy sample (Roussel+, 2007)',
 'J/ApJ/671/333: Aperture photometry in NGC 5194 (Kennicutt+, 2007)',
 'J/ApJ/693/1821: The Spitzer infrared nearby galaxies survey (Dale+, 2009)',
 'J/ApJ/695/580: Oxygen abundance in M83 (Bresolin+, 2009)',
 'J/ApJ/701/1965: Radial dust properties of SINGS galaxies (Munoz-Mateos+, 2009)',
 'J/ApJ/703/517: The Spitzer Local Volume Legacy: IR photometry (Dale+, 2009)',
 'J/ApJ/703/1569: Radial distribution in SINGS galaxies. I. (Munoz-Mateos+, 2009)',
 'J/ApJ/703/1672: Far-IR and H{alpha} fluxes in galaxies (Kennicutt+, 2009)',
 'J/ApJ/706/553: Fluxes in nearby star-forming galaxies (Boquien+, 2009)',
 'J/ApJ/706/599: H{alpha} and UV SFR in the local volume (Lee+, 2009)',
 'J/ApJ/714/1256: Far-IR star formation rate indicators (Calzetti+, 2010)',
 'J/ApJ/715/506: Aromatic inventory of the local volume (Marble+, 2010)',
 'J/ApJ/731/28: UV star-forming association in spiral galaxies (Alberts+, 2011)',
 'J/ApJ/737/L20: Metallicity dependent star formation rates (Dib, 2011)',
 'J/ApJ/744/44: H{alpha} and UV fluxes in nearby galaxies (Weisz+, 2012)',
 'J/ApJ/745/95: Herschel FIR & submm photometry of KINGFISH sample (Dale+, 2012)',
 'J/ApJ/757/52: UV and IR observations for SINGS galaxies. I. (Mao+, 2012)',
 'J/ApJ/767/51: Clusters of starburst galaxy NGC4214 (Andrews+, 2013)',
 'J/ApJ/772/27: Pa{alpha} (1.87um) LF of HII regions in 12 galaxies (Liu+, 2013)',
 'J/ApJ/772/107: Giant molecular clouds in nearby galaxies (Donovan Meyer+, 2013)',
 'J/ApJ/824/71: Compact star clusters in M51 with HST (Chandar+, 2016)',
 'J/ApJS/73/661: H II regions in M 101 (Hodge+ 1990)',
 'J/ApJS/164/81: Spectrophotometry of nearby galaxies (Moustakas+, 2006)',
 'J/ApJS/165/307: Survey for ionization in neutral gas galaxies. I. (Meurer+, 2006)',
 'J/ApJS/173/572: GALEX/Spitzer photometry in NGC 7331 (Thilker+, 2007)',
 'J/ApJS/178/247: H{alpha} and [NII] survey in local 11 Mpc (Kennicutt+, 2008)',
 'J/ApJS/190/233: Spectroscopy and abundances of SINGS galaxies (Moustakas+, 2010)',
 'J/ApJS/192/6: A GALEX UV imaging survey of nearby galaxies (Lee+, 2011)',
 'J/ApJS/199/36: H{alpha} survey of nearby clusters of galaxies (Sakai+, 2012)',
 'J/A+A/546/A2: Spectroscopy of HII regions in nearby galaxies (Sanchez+, 2012)',
 'J/A+A/552/A19: Radio-farIR correlation in NGC 6946 (Tabatabaei+, 2013)',
 'J/A+A/559/A114: Updated O3N2 and N2 abundance indicators (Marino+, 2013)',
 'J/A+A/576/A33: KINGFISH galaxy sample radial profile SED (Hunt+, 2015)',
 'J/A+A/576/A135: CALIFA DR2 (Garcia-Benito+, 2015)',
 'J/A+A/584/A87: CALIFA sample SFR calibration (Catalan-Torrecilla+, 2015)',
 'J/A+A/595/A43: Photometry of 119 HII regions in M33 (Relano+, 2016)',
 'J/AJ/130/1324: Faint emission-line galaxies at z<=1.6 (Drozdovsky+, 2005)',
 'J/AJ/132/231: MMT hectospec redshift survey of 24um sources (Papovich+, 2006)',
 'J/AJ/136/2563: HI Nearby Galaxy Survey, THINGS (Walter+, 2008)',
 'J/AJ/139/279: Outlying HII regions in HI-selected galaxies (Werk+, 2010)',
 'J/AJ/141/23: HI holes in THINGS galaxies (Bagetakos+, 2011)',
 'J/MNRAS/403/683: GALEX Arecibo SDSS survey (GASS) (Catinella+, 2010)',
 'J/MNRAS/405/857: Star clusters in NGC 3256 (Goddard+, 2010)',
 'J/MNRAS/412/1539: Ages of stars in dwarf galaxies (Bastian+, 2011)',
 'J/MNRAS/433/543: Choirs, HI galaxy groups (Sweet+, 2013)',
 'J/MNRAS/445/881: LVL global optical photometry (Cook+, 2014)',
 'J/MNRAS/445/899: LVL SEDs and physical properties (Cook+, 2014)',
 'J/MNRAS/454/3664: Abundance gradients in low SB spirals (Bresolin+, 2015)']



In [3]:

    
Vizier.get_catalogs('J/ApJS/178/247')









    Out[3]:





TableList with 2 tables:
	'0:J/ApJS/178/247/11Mpc' with 20 column(s) and 50 row(s) 
	'1:J/ApJS/178/247/refs' with 4 column(s) and 50 row(s)



In [4]:

    
Vizier.get_catalogs('J/ApJS/178/247')[0]









    Out[4]:




Table masked=True length=50

Seq Name n_Name RAJ2000 DEJ2000 TT Bmag cz vLG Dist l_logf logf l_EW EW BMAG NII_Ha l_LHa LHa SimbadName NED
"h:m:s" "d:m:s" mag km / s km / s Mpc [mW/m2] 0.1 nm mag [10-7W] 
int16 bytes14 bytes1 bytes10 bytes9 int16 float32 int16 int16 float32 bytes1 float32 bytes1 float64 float32 float32 bytes1 float32 bytes24 bytes3
1 UGC12894 s 00 00 22.5 +39 29 44 10 16.55 335 618 8.20 -13.42 -- -13.48 0.04 38.58 UGC12894 NED
2 WLM p 00 01 58.1 -15 27 39 10 11.03 -122 -16 0.92 -11.68 25.0 -13.91 0.04 38.34 WLM NED
3 ESO409-IG015 s 00 05 31.8 -28 05 53 6 15.14 737 780 10.40 -12.34 262.0 -15.02 0.07 39.77 ESO409-IG015 NED
4 ESO349-G031 s 00 08 13.3 -34 34 42 10 15.56 221 230 3.21 < -15.10 0.0 -12.03 0.02 < 36.00 ESO349-G031 NED
5 NGC24 p 00 09 56.7 -24 57 44 5 12.19 554 610 8.10 -11.87 19.0 -17.43 0.17 39.98 NGC24 NED
6 NGC45 p 00 14 04.0 -23 10 55 8 11.32 467 530 7.10 -11.22 38.0 -18.00 0.22 40.49 NGC45 NED
7 NGC55 p 00 14 54.0 -39 11 49 9 8.42 129 111 2.17 -10.12 41.0 -18.32 0.25 40.55 NGC55 NED
8 NGC59 s 00 15 25.4 -21 26 42 -3 13.12 362 432 5.30 -12.36 38.0 -15.58 0.08 39.15 NGC59 NED
9 MCG-04-02-003 s 00 19 11.4 -22 40 06 9 15.57 669 731 9.80 -13.15 26.0 -14.45 0.05 38.90 MCG-04-02-003 NED
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
41 NGC891 s 02 22 33.4 +42 20 57 3 10.81 528 738 9.20 -11.35 15.0 -19.29 0.36 40.59 NGC891 NED
42 UGC1865 p 02 25 00.2 +36 02 16 9 14.37 580 774 9.20 -12.73 30.0 -15.69 0.09 39.30 UGC1865 NED
43 NGC925 p 02 27 16.9 +33 34 45 7 10.69 553 739 9.16 -11.08 25.0 -19.41 0.38 40.85 NGC925 NED
44 UGC1924 s 02 27 49.8 +31 43 36 6 15.23 598 778 10.40 -13.42 -- -15.16 0.07 38.74 UGC1924 NED
45 NGC949 p 02 30 48.6 +37 08 14 4 12.40 609 801 9.20 -11.78 26.0 -17.62 0.19 40.20 NGC949 NED
46 NGC959 p 02 32 24.0 +35 29 42 8 12.95 597 784 9.20 -12.09 38.0 -17.09 0.28 39.86 NGC959 NED
47 UGC2014 s 02 32 54.0 +38 40 50 10 15.65 565 760 9.20 -13.34 16.0 -14.35 0.05 38.69 UGC2014 NED
48 UGC2023 p 02 33 18.2 +33 29 28 10 13.88 589 770 9.20 -12.41 32.0 -16.30 0.10 39.64 UGC2023 NED
49 UGC2034 s 02 33 42.9 +40 31 41 10 13.70 578 777 9.20 -12.51 11.0 -16.32 0.11 39.50 UGC2034 NED
50 ESO115-G021 p 02 37 48.1 -61 20 18 8 13.34 515 339 4.99 -12.11 31.0 -15.21 0.07 39.35 ESO115-G021 NED

Customize class to get all columns and all lines (limited to 50 by default):



In [5]:

    
Custom_Vizier = Vizier(columns=['**'])
Custom_Vizier.ROW_LIMIT = -1



In [6]:

    
Custom_Vizier.get_catalogs('J/ApJS/178/247')[0]









    Out[6]:




Table masked=True length=436

Seq Name n_Name RAJ2000 DEJ2000 GLat TT Bmag e_Bmag cz vLG Dist n_Dist Ref l_logf logf e_logf l_EW EW e_EW n_EW Tel Cover AB BMAG NII_Ha r_NII_Ha l_LHa LHa SimbadName NED
"h:m:s" "d:m:s" deg mag mag km / s km / s Mpc [mW/m2] [mW/m2] 0.1 nm 0.1 nm mag mag [10-7W] 
int16 bytes14 bytes1 bytes10 bytes9 float32 int16 float32 float32 int16 int16 float32 bytes7 bytes7 bytes1 float32 float32 bytes1 float64 float32 float32 bytes4 float32 float32 float32 float32 uint8 bytes1 float32 bytes24 bytes3
1 UGC12894 s 00 00 22.5 +39 29 44 -22.32 10 16.55 0.20 335 618 8.20 v(flow) 120 -13.42 0.030 -- -- 2.3 -- 0.45 -13.48 0.04 3 38.58 UGC12894 NED
2 WLM p 00 01 58.1 -15 27 39 -73.63 10 11.03 0.08 -122 -16 0.92 trgb 11, 118 -11.68 0.130 25.0 9.0 1.1 KPNO 2.2 0.13 -13.91 0.04 3 38.34 WLM NED
3 ESO409-IG015 s 00 05 31.8 -28 05 53 -79.79 6 15.14 0.19 737 780 10.40 v(flow) 111 -12.34 0.040 262.0 26.0 2.1 -- 0.08 -15.02 0.07 3 39.77 ESO409-IG015 NED
4 ESO349-G031 s 00 08 13.3 -34 34 42 -78.12 10 15.56 0.20 221 230 3.21 trgb 7, 111 < -15.10 -- 0.0 -- 2.2 -- 0.05 -12.03 0.02 3 < 36.00 ESO349-G031 NED
5 NGC24 p 00 09 56.7 -24 57 44 -80.43 5 12.19 0.13 554 610 8.10 v(flow) 118 -11.87 0.040 19.0 1.0 2.1 -- 0.07 -17.43 0.17 3 39.98 NGC24 NED
6 NGC45 p 00 14 04.0 -23 10 55 -80.67 8 11.32 0.08 467 530 7.10 v(flow) 118 -11.22 0.040 38.0 10.0 2.2 -- 0.07 -18.00 0.22 3 40.49 NGC45 NED
7 NGC55 p 00 14 54.0 -39 11 49 -75.74 9 8.42 0.05 129 111 2.17 trgb 62, 118 -10.12 0.020 41.0 10.0 2.2 -- 0.06 -18.32 0.25 3 40.55 NGC55 NED
8 NGC59 s 00 15 25.4 -21 26 42 -80.02 -3 13.12 0.14 362 432 5.30 sbf 21, 118 -12.36 0.060 38.0 5.0 1.2 KPNO 1.0 0.07 -15.58 0.08 3 39.15 NGC59 NED
9 MCG-04-02-003 s 00 19 11.4 -22 40 06 -81.44 9 15.57 0.32 669 731 9.80 v(flow) 111 -13.15 0.050 26.0 3.0 2.1 -- 0.07 -14.45 0.05 3 38.90 MCG-04-02-003 NED
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
427 ESO347-G017 p 23 26 56.0 -37 20 49 -69.49 9 14.40 -- 692 703 9.40 v(flow) 114 -12.53 0.050 34.0 4.0 1.1 CTIO 1.0 0.07 -15.52 0.08 3 39.48 ESO347-G017 NED
428 UGC12613 p 23 28 36.2 +14 44 35 -43.55 10 12.50 0.15 -183 60 0.76 trgb 59, 120 -13.38 0.140 1.0 1.0 1.1 KPNO 1.0 0.19 -12.09 0.02 3 36.50 UGC12613 NED
429 UGC12632 s 23 29 58.7 +40 59 25 -19.31 9 12.78 0.17 422 718 9.60 v(flow) 118 -12.18 0.040 40.0 6.0 1.2 KPNO 2.0 0.56 -17.69 0.19 3 39.92 UGC12632 NED
430 IC5332 p 23 34 27.4 -36 06 05 -71.37 7 11.21 0.15 701 715 9.50 v(flow) 111 -11.31 0.060 23.0 4.0 2.1 -- 0.07 -18.76 0.29 3 40.63 IC5332 NED
431 NGC7713 p 23 36 15.4 -37 56 19 -70.88 7 11.51 0.15 692 696 9.30 v(flow) 118 -11.49 0.060 47.0 5.0 2.1 -- 0.07 -18.40 0.15 1 40.48 NGC7713 NED
432 UGC12713 p 23 38 14.4 +30 42 29 -29.58 0 14.91 0.03 299 578 7.70 v(flow) 120 -12.83 0.050 29.0 4.0 1.1 KPNO 1.0 0.25 -14.78 0.04 2 39.07 UGC12713 NED
433 UGCA442 p 23 43 45.5 -31 57 22 -74.53 9 13.60 0.15 267 300 4.27 trgb 31, 118 -12.46 0.050 25.0 4.0 1.1 CTIO 1.0 0.07 -14.62 0.06 3 38.87 UGCA442 NED
434 ESO348-G009 s 23 49 23.5 -37 46 19 -73.17 10 16.70 0.70 648 648 8.60 v(flow) 111 -13.17 0.050 17.0 2.0 2.1 -- 0.06 -13.00 0.03 3 38.78 ESO348-G009 NED
435 ESO149-G003 s 23 52 02.8 -52 34 40 -62.24 10 15.04 0.14 576 500 6.40 tf 31, 111 -12.74 0.030 43.0 3.0 2.1 -- 0.06 -14.05 0.04 3 38.95 ESO149-G003 NED
436 NGC7793 p 23 57 49.7 -32 35 30 -77.17 7 9.63 0.05 227 250 3.91 trgb 31, 118 -10.60 0.080 40.0 10.0 2.1 -- 0.08 -18.41 0.25 3 40.58 NGC7793 NED

SQL in SDSS



In [8]:

    
from astroquery.sdss import SDSS

sdss = SDSS()

query = "select top 10 z, ra, dec, bestObjID from specObj where class = 'galaxy' and z > 0.3 and zWarning = 0"
        
sdss.query_sql(query)









    Out[8]:




Table length=10

z ra dec bestObjID
float64 float64 float64 int64
0.3000005 174.54051 24.200028 1237667549812162759
0.3000012 49.459411 0.847754 1237660241924063461
0.3000027 156.25024 7.6586271 1237658425162858683
0.3000035 184.90501 -3.3095095 1237650760782053596
0.3000046 175.65125 34.37548 1237665128003731630
0.3000049 355.06402 11.065502 1237679320160993477
0.3000053 236.61952 0.79678773 1237655468065620483
0.3000054 138.22411 22.719858 1237667111721042523
0.3000055 156.156 49.615565 1237657857677000910
0.3000057 234.24011 7.7657256 1237661949202137472

Query for the same object either by name or by coordinates



In [9]:

    
from astropy.coordinates import SkyCoord
coord_hd189 = SkyCoord('20h00m43.71s +22d42m39.07s')



In [10]:

    
from astroquery.esasky import ESASky
esasky = ESASky()



In [11]:

    
esasky.query_object_catalogs(coord_hd189)









    Out[11]:





TableList with 6 tables:
	'0:XMM-EPIC' with 6 column(s) and 17 row(s) 
	'1:TYCHO-2' with 7 column(s) and 1 row(s) 
	'2:HIPPARCOS-2' with 7 column(s) and 1 row(s) 
	'3:GAIA DR1 TGAS' with 10 column(s) and 1 row(s) 
	'4:XMM-OM' with 12 column(s) and 5 row(s) 
	'5:GAIA DR1' with 7 column(s) and 1 row(s)



In [12]:

    
esasky.query_object_catalogs('HD189733')









    Out[12]:





TableList with 6 tables:
	'0:XMM-EPIC' with 6 column(s) and 17 row(s) 
	'1:TYCHO-2' with 7 column(s) and 1 row(s) 
	'2:HIPPARCOS-2' with 7 column(s) and 1 row(s) 
	'3:GAIA DR1 TGAS' with 10 column(s) and 1 row(s) 
	'4:XMM-OM' with 12 column(s) and 5 row(s) 
	'5:GAIA DR1' with 7 column(s) and 1 row(s)



In [ ]:

Seq	Name	n_Name	RAJ2000	DEJ2000	TT	Bmag	cz	vLG	Dist	l_logf	logf	l_EW	EW	BMAG	NII_Ha	l_LHa	LHa	SimbadName	NED
			"h:m:s"	"d:m:s"		mag	km / s	km / s	Mpc		[mW/m2]		0.1 nm	mag			[10-7W]
int16	bytes14	bytes1	bytes10	bytes9	int16	float32	int16	int16	float32	bytes1	float32	bytes1	float64	float32	float32	bytes1	float32	bytes24	bytes3
1	UGC12894	s	00 00 22.5	+39 29 44	10	16.55	335	618	8.20		-13.42		--	-13.48	0.04		38.58	UGC12894	NED
2	WLM	p	00 01 58.1	-15 27 39	10	11.03	-122	-16	0.92		-11.68		25.0	-13.91	0.04		38.34	WLM	NED
3	ESO409-IG015	s	00 05 31.8	-28 05 53	6	15.14	737	780	10.40		-12.34		262.0	-15.02	0.07		39.77	ESO409-IG015	NED
4	ESO349-G031	s	00 08 13.3	-34 34 42	10	15.56	221	230	3.21	<	-15.10		0.0	-12.03	0.02	<	36.00	ESO349-G031	NED
5	NGC24	p	00 09 56.7	-24 57 44	5	12.19	554	610	8.10		-11.87		19.0	-17.43	0.17		39.98	NGC24	NED
6	NGC45	p	00 14 04.0	-23 10 55	8	11.32	467	530	7.10		-11.22		38.0	-18.00	0.22		40.49	NGC45	NED
7	NGC55	p	00 14 54.0	-39 11 49	9	8.42	129	111	2.17		-10.12		41.0	-18.32	0.25		40.55	NGC55	NED
8	NGC59	s	00 15 25.4	-21 26 42	-3	13.12	362	432	5.30		-12.36		38.0	-15.58	0.08		39.15	NGC59	NED
9	MCG-04-02-003	s	00 19 11.4	-22 40 06	9	15.57	669	731	9.80		-13.15		26.0	-14.45	0.05		38.90	MCG-04-02-003	NED
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
41	NGC891	s	02 22 33.4	+42 20 57	3	10.81	528	738	9.20		-11.35		15.0	-19.29	0.36		40.59	NGC891	NED
42	UGC1865	p	02 25 00.2	+36 02 16	9	14.37	580	774	9.20		-12.73		30.0	-15.69	0.09		39.30	UGC1865	NED
43	NGC925	p	02 27 16.9	+33 34 45	7	10.69	553	739	9.16		-11.08		25.0	-19.41	0.38		40.85	NGC925	NED
44	UGC1924	s	02 27 49.8	+31 43 36	6	15.23	598	778	10.40		-13.42		--	-15.16	0.07		38.74	UGC1924	NED
45	NGC949	p	02 30 48.6	+37 08 14	4	12.40	609	801	9.20		-11.78		26.0	-17.62	0.19		40.20	NGC949	NED
46	NGC959	p	02 32 24.0	+35 29 42	8	12.95	597	784	9.20		-12.09		38.0	-17.09	0.28		39.86	NGC959	NED
47	UGC2014	s	02 32 54.0	+38 40 50	10	15.65	565	760	9.20		-13.34		16.0	-14.35	0.05		38.69	UGC2014	NED
48	UGC2023	p	02 33 18.2	+33 29 28	10	13.88	589	770	9.20		-12.41		32.0	-16.30	0.10		39.64	UGC2023	NED
49	UGC2034	s	02 33 42.9	+40 31 41	10	13.70	578	777	9.20		-12.51		11.0	-16.32	0.11		39.50	UGC2034	NED
50	ESO115-G021	p	02 37 48.1	-61 20 18	8	13.34	515	339	4.99		-12.11		31.0	-15.21	0.07		39.35	ESO115-G021	NED